﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Oracle.DataAccess.Client;

namespace Wicresoft.SelfService.DAO
{
    public struct QueryParameters
    {
        public string OracleDbName;
        public OracleDbType OracleDbType;
        public int OracleDbSize;
        public object OracleDbValue;
        public QueryOperatorType QueryOperator;
        public PredicateType PredicateType;
    }

    public enum QueryOperatorType
    {
        equal = 1,
        notEqual = 2,
        like = 3,
        bigger = 4,
        notBigger = 5,
        smaller = 6,
        notSmaller = 7,
        isNull = 8,
        isNotNull = 9
    }

    public enum PredicateType
    {
        set = 1,
        where = 2,
        on = 3
    }

    public struct OrderbyParameters
    {
        public string orderByCol;
        public orderByType orderByType;
    }
    public enum orderByType
    {
        ascending = 1,
        descending = 2
    }
    public enum DBMType
    {
        select = 1,
        update = 2,
        insert = 3,
        delete = 4
    }
}
